﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Clinica/MasterPagePromociones.master" AutoEventWireup="true" CodeFile="wfSegmentarPaciente.aspx.cs" Inherits="wfSegmentarPaciente" %>

<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxTabControl" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxClasses" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxRoundPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.2.Export, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView.Export" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v11.2.Export, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid.Export" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPopupControl" tagprefix="dx" %>

<%@ Register assembly="DevExpress.XtraReports.v11.2.Web, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraReports.Web" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxNewsControl" tagprefix="dx" %>

<%@ Register assembly="DevExpress.XtraCharts.v11.2.Web, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraCharts.Web" tagprefix="dxchartsui" %>
<%@ Register assembly="DevExpress.XtraCharts.v11.2, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraCharts" tagprefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style1
        {
            height: 16px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentMenuSecundario" Runat="Server">
   <li><a href="wfGenerarReportePaciente.aspx"   class="">Generar Reporte de Paciente</a></li>
    <li><a href="wfSegmentarPaciente.aspx" class="">Segmentar Clientes</a></li>
    <li><a href="wfCargarPromocion.aspx" class="">Cargar Promociones</a></li>
    <li><%--<a href="wfIndicadores.aspx" class="">Indicadores</a>--%></li>
    <li><%--<a href="wfEspecialidadesReporte.aspx" class="">Especialidades</a>--%></li>
    <li><%--<a href="wfSugerenciasReporte.aspx" class="">Sugerencias</a>--%></li>
    <li><%--<a href="wfQuejasReporte.aspx" class="">Quejas</a>--%></li>
    <li><%--<a href="wfReclamosReporte.aspx" class="">Reclamos</a>--%></li>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ModuleTitleContent" Runat="Server">
    Segmentar Clientes  
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="ContentEnlacesRapidos" Runat="Server">
</asp:Content>
<asp:Content ID="Content5" ContentPlaceHolderID="MainContent" Runat="Server">
    <ul class="tabs primary">
        <li><a href="wfIndicadores.aspx">Generar Reporte</a></li>
       </ul>
  
    <table>
        <tr>
            <td colspan="2" rowspan="2">
                <dx:ASPxRoundPanel ID="panelMessage" runat="server" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                    CssPostfix="PlasticBlue" Font-Size="XX-Small" ClientIDMode="AutoID" GroupBoxCaptionOffsetY="-18px"
                    SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" 
                    ShowHeader="False" Height="58px" Width="341px">
                    <PanelCollection>
                        <dx:PanelContent ID="PanelContent1" runat="server">
                            <table>
                                <tr>
                                    <td class="style1">
                                        Click en la celda para obtener el detalle del resultado.
                                    </td>
                                </tr>
                            </table>
                            <table>
                                <tr>
                                    <td>
                                        Opciones de Fila:
                                    </td>
                                    <td>
                                        <dx:ASPxCheckBox ID="ShowRowSubTotals" runat="server" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                            CssPostfix="PlasticBlue" Font-Size="X-Small" Text="Mostrar la fila de Sub Totales"
                                            AutoPostBack="True" Checked="True" 
                                            OnCheckedChanged="ShowRowSubTotals_CheckedChanged" 
                                            SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" TextSpacing="2px">
                                        </dx:ASPxCheckBox>
                                    </td>
                                    <td>
                                        <dx:ASPxCheckBox ID="ShowColumnSubTotals" runat="server" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                            CssPostfix="PlasticBlue" Font-Size="X-Small" Text="Mostrar la columna de Sub Totales"
                                            AutoPostBack="True" Checked="True" 
                                            OnCheckedChanged="ShowColumnSubTotals_CheckedChanged" 
                                            SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" TextSpacing="2px">
                                        </dx:ASPxCheckBox>
                                    </td>
                                </tr>
                            </table>
                        </dx:PanelContent>
                    </PanelCollection>
                    <ContentPaddings PaddingBottom="8px" />
                </dx:ASPxRoundPanel>
                </td>
            <td rowspan="3">
                            &nbsp;</td>
            <td rowspan="3">
                &nbsp;</td>
            <td>
                <dx:ASPxButton ID="btnCargar" runat="server" ClientIDMode="AutoID" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                    CssPostfix="PlasticBlue" SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css"
                    Text="Cargar Reporte" Font-Size="X-Small" 
                    onclick="btnCargar_Click">
                </dx:ASPxButton>
            </td>
            <td>
                <dx:ASPxComboBox ID="cboReportes" runat="server" 
                    CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" CssPostfix="PlasticBlue" 
                    SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" 
                    DataSourceID="SqlDataSource2" TextField="Nombre_Reporte" ValueField="idReporte" 
                    Width="264px" Height="16px">
                    <LoadingPanelImage Url="~/App_Themes/PlasticBlue/Editors/Loading.gif">
                    </LoadingPanelImage>
                    <ValidationSettings>
                        <ErrorFrameStyle ImageSpacing="4px">
                            <ErrorTextPaddings PaddingLeft="4px" />
                        </ErrorFrameStyle>
                    </ValidationSettings>
                </dx:ASPxComboBox>
            </td>
            <td rowspan="2">
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BDClinicaConnectionString %>" 
                    SelectCommand="SELECT * FROM [MAR_REPORTES_SEG]">
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                <dx:ASPxLabel ID="ASPxLabel2" runat="server" Text="Nombre de Reporte">
                </dx:ASPxLabel>
            </td>
        </tr>
        <tr>
            <td>
                <dx:ASPxButton ID="btnVerInforme" runat="server" ClientIDMode="AutoID" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                    CssPostfix="PlasticBlue" SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css"
                    Text="Ver Informe" Font-Size="X-Small" onclick="btnVerInforme_Click" 
                    Height="22px">
                </dx:ASPxButton>
                </td>
            <td>
                <dx:ASPxButton ID="btnVerGrafico" runat="server" ClientIDMode="AutoID" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                    CssPostfix="PlasticBlue" SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css"
                    Text="Ver Gráfico" Font-Size="X-Small" 
                    onclick="btnVerGrafico_Click">
                </dx:ASPxButton>
                </td>
            <td>
                <dx:ASPxButton ID="btnGuardar" runat="server" ClientIDMode="AutoID" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                    CssPostfix="PlasticBlue" SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css"
                    Text="Guardar Reporte" Font-Size="X-Small" 
                    onclick="btnGuardar_Click">
                </dx:ASPxButton>
            </td>
            <td>
                <dx:ASPxTextBox ID="txtNomCampo" runat="server" Width="266px">
                </dx:ASPxTextBox>
            </td>
            <td>
                &nbsp;</td>
        </tr>
        </table>
    <table width="99%" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <th scope="col" valign="top" align="left" width="99%">
                <dx:ASPxPivotCustomizationControl ID="ASPxPivotCustomizationControl1" 
                    runat="server" AllowFilter="True" AllowSort="True" 
                    ASPxPivotGridID="dgCuboAdmPaciente" Height="394px" Width="345px">
                </dx:ASPxPivotCustomizationControl>
                <br />
                            <dx:ASPxRoundPanel ID="ASPxRoundPanel2" runat="server" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                CssPostfix="PlasticBlue" Font-Size="XX-Small" 
                    ClientIDMode="AutoID" GroupBoxCaptionOffsetY="-18px"
                                SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" 
                    ShowHeader="False" style="margin-bottom: 0px">
                                <PanelCollection>
                                    <dx:PanelContent ID="PanelContent2" runat="server">
                                        <table border="0" cellpadding="3" cellspacing="0">
                                            <tr>
                                                <td>
                                                    Exportar a:
                                                </td>
                                                <td>
                                                    <dx:ASPxComboBox ID="listExportFormat" runat="server" Style="vertical-align: middle"
                                                        SelectedIndex="0" ValueType="System.String" Width="61px" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                                        CssPostfix="PlasticBlue" Font-Size="XX-Small" SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css">
                                                        <Items>
                                                            <dx:ListEditItem Text="Pdf" Value="0" />
                                                            <dx:ListEditItem Text="Excel" Value="1" />
                                                            <dx:ListEditItem Text="Mht" Value="2" />
                                                            <dx:ListEditItem Text="Rtf" Value="3" />
                                                            <dx:ListEditItem Text="Text" Value="4" />
                                                            <dx:ListEditItem Text="Html" Value="5" />
                                                        </Items>
                                                        <LoadingPanelImage Url="~/App_Themes/PlasticBlue/Editors/Loading.gif">
                                                        </LoadingPanelImage>
                                                        <ValidationSettings>
                                                            <ErrorFrameStyle ImageSpacing="4px">
                                                                <ErrorTextPaddings PaddingLeft="4px" />
                                                            </ErrorFrameStyle>
                                                        </ValidationSettings>
                                                    </dx:ASPxComboBox>
                                                </td>
                                                <td>
                                                    <dx:ASPxButton ID="buttonSaveAs" runat="server" ToolTip="Exportar y guardar" 
                                                        Style="vertical-align: middle;" Text="Guardar" Width="51px" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                                        CssPostfix="PlasticBlue" Font-Size="XX-Small" 
                                                        SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" 
                                                        OnClick="buttonSaveAs_Click">
                                                    </dx:ASPxButton>
                                                </td>
                                                <td>
                                                    <dx:ASPxButton ID="buttonOpen" runat="server" ToolTip="Exportar y abrir" 
                                                        Style="vertical-align: middle" Text="Abrir" Width="51px" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                                        CssPostfix="PlasticBlue" Font-Size="XX-Small" 
                                                        SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" 
                                                        OnClick="buttonOpen_Click">
                                                    </dx:ASPxButton>
                                                </td>
                                            </tr>
                                        </table>
                                        <table border="0" cellpadding="3" cellspacing="0">
                                            <tr>
                                                <td rowspan="5" valign="top" style="width: 106px">
                                                    Opciones de Exportación:
                                                </td>
                                                <td style="width: 250px">
                                                    <asp:CheckBox ID="checkPrintHeadersOnEveryPage" runat="server" Text="Imprimir cabeceras en cada p&#225;gina" />
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 250px">
                                                    <asp:CheckBox ID="checkPrintFilterHeaders" runat="server" Text="Imprimir cabeceras de filtro"
                                                        Checked="True" />
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 250px">
                                                    <asp:CheckBox ID="checkPrintColumnHeaders" runat="server" Text="Imprimir cabeceras de columna"
                                                        Checked="True" />
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 250px;">
                                                    <asp:CheckBox ID="checkPrintRowHeaders" runat="server" Text="Imprimir cabeceras de fila"
                                                        Checked="True" />
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 250px">
                                                    <asp:CheckBox ID="checkPrintDataHeaders" runat="server" Text="Imprimir cabeceras de datos"
                                                        Checked="True" />
                                                </td>
                                            </tr>
                                        </table>
                                    </dx:PanelContent>
                                </PanelCollection>
                                <ContentPaddings PaddingBottom="8px" />
                            </dx:ASPxRoundPanel>
                <br />
                <table>
                    <tr>
                        <td>
                <dx:ASPxRoundPanel ID="ASPxRoundPanel3" runat="server" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                CssPostfix="PlasticBlue" Font-Size="XX-Small" ClientIDMode="AutoID"
                                GroupBoxCaptionOffsetY="-18px" SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css"
                                ShowHeader="False">
                                <PanelCollection>
                                    <dx:PanelContent ID="PanelContent3" runat="server">
                                        <table>
                                            <tr>
                                                    <td>
                                                        <dx:ASPxLabel ID="ASPxLabel1" runat="server" Text="Tipo de Chart:" Font-Size="XX-Small">
                                                        </dx:ASPxLabel>
                                                    </td>
                                                    <td colspan="2">
                                                        <dx:ASPxComboBox ID="ChartType" runat="server" OnValueChanged="ChartType_ValueChanged"
                                                            AutoPostBack="true" Font-Size="XX-Small" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                                            CssPostfix="PlasticBlue" 
                                                            SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" 
                                                            OnSelectedIndexChanged="ChartType_SelectedIndexChanged">
                                                            <LoadingPanelImage Url="~/App_Themes/PlasticBlue/Editors/Loading.gif">
                                                            </LoadingPanelImage>
                                                            <ValidationSettings>
                                                                <ErrorFrameStyle ImageSpacing="4px">
                                                                    <ErrorTextPaddings PaddingLeft="4px" />
                                                                </ErrorFrameStyle>
                                                            </ValidationSettings>
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td>
                                                        Opciones de Chart:
                                                    </td>
                                                    <td>
                                                        <dx:ASPxCheckBox runat="server" Checked="False" Text="Mostrar columna Gran Totales"
                                                            AutoPostBack="True" ID="ShowColumnGrandTotals" OnCheckedChanged="ShowColumnGrandTotals_CheckedChanged"
                                                            Font-Size="XX-Small" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" 
                                                            CssPostfix="PlasticBlue" 
                                                            SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" TextSpacing="2px">
                                                        </dx:ASPxCheckBox>
                                                    </td>
                                                    <td>
                                                        <dx:ASPxCheckBox runat="server" Text="Mostrar la fila Gran Totales" AutoPostBack="True"
                                                            ID="ShowRowGrandTotals" OnCheckedChanged="ShowRowGrandTotals_CheckedChanged"
                                                            Font-Size="XX-Small" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" 
                                                            CssPostfix="PlasticBlue" 
                                                            SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" TextSpacing="2px">
                                                        </dx:ASPxCheckBox>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td>
                                                        &nbsp;
                                                    </td>
                                                    <td>
                                                        <dx:ASPxCheckBox runat="server" Text="Generar la serie de columnas" AutoPostBack="True"
                                                            ID="ChartDataVertical" OnCheckedChanged="ChartDataVertical_CheckedChanged" 
                                                            Font-Size="XX-Small" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" 
                                                            CssPostfix="PlasticBlue" 
                                                            SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" TextSpacing="2px">
                                                        </dx:ASPxCheckBox>
                                                    </td>
                                                    <td>
                                                        <dx:ASPxCheckBox ID="PointLabels" runat="server" Text="Mostrar las etiquetas de los puntos"
                                                            OnCheckedChanged="PointLabels_CheckedChanged" AutoPostBack="true" 
                                                            Font-Size="XX-Small" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" 
                                                            CssPostfix="PlasticBlue" 
                                                            SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" TextSpacing="2px">
                                                        </dx:ASPxCheckBox>
                                                    </td>
                                                </tr>
                                        </table>
                                    </dx:PanelContent>
                                </PanelCollection>
                                <ContentPaddings PaddingBottom="8px" />
                            </dx:ASPxRoundPanel>
                        </td>
                        <td>
                            
                        </td>
                    </tr>
                    <tr>
                        <td>
                <dx:ASPxPopupControl ID="ASPxPopupControl1" runat="server" Height="1px" AllowDragging="True"
                    ClientInstanceName="DrillDownWindow" Left="200" Top="200" CloseAction="CloseButton"
                    Width="153px" HeaderText="Ventana de Detalle" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                    CssPostfix="PlasticBlue" ClientIDMode="AutoID" SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css">
                    <ContentCollection>
                        <dx:PopupControlContentControl ID="PopupControlContentControl1" runat="server">
                            <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
                                ClientInstanceName="GridView" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                CssPostfix="PlasticBlue" Font-Size="XX-Small" 
                                DataSourceID="dgCuboAdmPaciente">
                                <ClientSideEvents EndCallback="function(s, e) {
	DrillDownWindow.SetClientWindowSize(-1, 100, 100);
}" />
                                <Columns>
                                    <dx:GridViewDataTextColumn FieldName="Arguments" ReadOnly="True" 
                                        ShowInCustomizationForm="True" VisibleIndex="0">
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn FieldName="Series" ReadOnly="True" 
                                        ShowInCustomizationForm="True" VisibleIndex="1">
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn FieldName="Values" ReadOnly="True" 
                                        ShowInCustomizationForm="True" VisibleIndex="2">
                                    </dx:GridViewDataTextColumn>
                                </Columns>
                                <SettingsPager ShowDefaultImages="False">
                                    <AllButton Text="All">
                                    </AllButton>
                                    <NextPageButton Text="Next &gt;">
                                    </NextPageButton>
                                    <PrevPageButton Text="&lt; Prev">
                                    </PrevPageButton>
                                </SettingsPager>
                                <SettingsLoadingPanel Mode="ShowOnStatusBar" />
                                <ImagesFilterControl>
                                    <LoadingPanel Url="~/App_Themes/PlasticBlue/Editors/Loading.gif">
                                    </LoadingPanel>
                                </ImagesFilterControl>
                                <Styles CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" CssPostfix="PlasticBlue">
                                    <Header ImageSpacing="10px" SortingImageSpacing="10px">
                                    </Header>
                                </Styles>
                                <Images SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css">
                                    <LoadingPanelOnStatusBar Url="~/App_Themes/PlasticBlue/GridView/gvLoadingOnStatusBar.gif">
                                    </LoadingPanelOnStatusBar>
                                    <LoadingPanel Url="~/App_Themes/PlasticBlue/GridView/Loading.gif">
                                    </LoadingPanel>
                                </Images>
                                <StylesEditors>
                                    <CalendarHeader Spacing="11px">
                                    </CalendarHeader>
                                    <ProgressBar Height="25px">
                                    </ProgressBar>
                                </StylesEditors>
                            </dx:ASPxGridView>
                            <dx:ASPxButton ID="ASPxButton1" runat="server" Text="Exportar a Excel" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
                                CssPostfix="PlasticBlue" Font-Size="XX-Small" 
                                SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css">
                            </dx:ASPxButton>
                        </dx:PopupControlContentControl>
                    </ContentCollection>
                    <CloseButtonStyle>
                        <Paddings Padding="0px" />
                    </CloseButtonStyle>
                    <ContentStyle>
                        <BorderBottom BorderColor="#E0E0E0" BorderStyle="Solid" BorderWidth="1px" />
                    </ContentStyle>
                    <HeaderStyle>
                        <Paddings PaddingRight="4px" PaddingBottom="4px" PaddingLeft="10px" PaddingTop="4px" />
                    </HeaderStyle>
                </dx:ASPxPopupControl>
                        </td>
                        <td>
                            
                            &nbsp;</td>
                    </tr>
                </table>
                <br />
            </th>
            <th scope="col" valign="top" align="left" width="99%" style="width: 49%">
                <div style="overflow: scroll; width: 950px; margin: 0 0 0 0; height: 464px;">
                    <dx:ASPxPivotGrid ID="dgCuboAdmPaciente" runat="server" ClientIDMode="AutoID" 
                        DataSourceID="SqlDataSource1">
                        <Fields>
                            <dx:PivotGridField ID="fieldNumeroCita" FieldName="Numero Cita" Visible="False" 
                                SummaryType="Count" Caption="Nro. Cita">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldFechadeCita" AreaIndex="0" FieldName="Fecha de Cita" 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldEstadoCita" AreaIndex="0" 
                                FieldName="Estado Cita" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldCodigoPromocion" AreaIndex="0" 
                                FieldName="Codigo Promocion" Visible="False" SummaryType="Count" 
                                Caption="Cod. Promocion">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldObservacionCita" AreaIndex="0" 
                                FieldName="Observacion Cita" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldEspecialidad" AreaIndex="0" FieldName="Especialidad" 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldCodigoDpto" AreaIndex="0" 
                                FieldName="Codigo Dpto." Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldDepartamento" AreaIndex="0" FieldName="Departamento" 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNombrePromocion" AreaIndex="0" 
                                FieldName="Nombre Promocion" Visible="False" SummaryType="Count" 
                                Caption="Promocion">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldFechaProgramacion" AreaIndex="0" FieldName="Fecha Programacion" 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldTipoProgramacion" AreaIndex="0" 
                                FieldName="Tipo Programacion" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldEstadoProgMed" AreaIndex="0" FieldName="Estado Prog. Med." 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldCodigoMedico" AreaIndex="0" 
                                FieldName="Codigo Medico" Visible="False" SummaryType="Count" 
                                Caption="Cod. Medico">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNombreMedico" AreaIndex="0" 
                                FieldName="Nombre Medico" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldHorario" AreaIndex="0" 
                                FieldName="Horario" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldTurno" AreaIndex="0" FieldName="Turno" 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldFechaNacimiento" AreaIndex="0" 
                                FieldName="Fecha Nacimiento" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNroDocumento" AreaIndex="0" 
                                FieldName="Nro Documento" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldTelefono" AreaIndex="3" 
                                FieldName="Telefono" SummaryType="Count" Area="RowArea" 
                                Options-AllowDrag="False" Options-AllowDragInCustomizationForm="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldDomicilio" AreaIndex="0" 
                                FieldName="Domicilio" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldCodigoPaciente" AreaIndex="0" 
                                FieldName="Codigo Paciente" SummaryType="Count" Area="RowArea" 
                                Options-AllowDrag="False" Options-AllowDragInCustomizationForm="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNroDomicilio" AreaIndex="0" 
                                FieldName="Nro Domicilio" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldPisoDomicilio" AreaIndex="0" FieldName="Piso Domicilio" 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldManzanaDomicilio" AreaIndex="0" 
                                FieldName="Manzana Domicilio" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldLoteDomicilio" AreaIndex="0" 
                                FieldName="Lote Domicilio" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldSectorDomicilio" AreaIndex="0" 
                                FieldName="Sector Domicilio" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldEtapaDomicilio" AreaIndex="0" 
                                FieldName="Etapa Domicilio" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldObservacionPaciente" AreaIndex="0" 
                                FieldName="Observacion Paciente" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNumeroSeguro" AreaIndex="0" 
                                FieldName="Numero Seguro" Visible="False" SummaryType="Count" 
                                Caption="Nro. Paciente">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNumeroPaciente" AreaIndex="0" 
                                FieldName="Numero Paciente" Visible="False" SummaryType="Count" 
                                Caption="Nro Paciente">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNombrePaciente" AreaIndex="1" 
                                FieldName="Nombre Paciente" SummaryType="Count" Area="RowArea" 
                                Options-AllowDrag="False" Options-AllowDragInCustomizationForm="False" 
                                Caption="Nombre Paciente">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldAoCIta" AreaIndex="0" 
                                FieldName="Año CIta" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldMesCita" AreaIndex="0" 
                                FieldName="Mes Cita" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldAoNacimiento" AreaIndex="0" 
                                FieldName="Año Nacimiento" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldMesNacieminto" AreaIndex="0" 
                                FieldName="Mes Nacieminto" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldTipoTrabajo" AreaIndex="0" 
                                FieldName="Tipo Trabajo" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldEstadoCivil" AreaIndex="0" 
                                FieldName="Estado Civil" Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldDocumentoIndentidad" AreaIndex="0" 
                                FieldName="Documento Indentidad" SummaryType="Count" Visible="False" 
                                Caption="Doc. Indentidad">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldSexo" AreaIndex="0" FieldName="Sexo" 
                                SummaryType="Count" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldEdad" AreaIndex="0" FieldName="Edad" 
                                SummaryType="Count" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNroHijos" AreaIndex="0" FieldName="Nro Hijos" 
                                Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldPeso" AreaIndex="0" FieldName="Peso" 
                                Visible="False" SummaryType="Count">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldTipodeSangre" AreaIndex="0" 
                                FieldName="Tipo de Sangre" SummaryType="Count" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldAlergia" AreaIndex="0" FieldName="Alergia" 
                                SummaryType="Count" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldFechaUltAtencionOdontologica" AreaIndex="0" 
                                FieldName="Fecha Ult. Atencion Odontologica" SummaryType="Count" 
                                Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldFechaUltChequeoGeneral" AreaIndex="0" 
                                FieldName="Fecha Ult. Chequeo General" SummaryType="Count" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldOtrasAlergias" AreaIndex="0" 
                                FieldName="Otras Alergias" SummaryType="Count" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldNombreEnfermedad" AreaIndex="0" 
                                FieldName="Nombre Enfermedad" SummaryType="Count" Visible="False" 
                                Caption="Enfermedad">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldCorreo1" AreaIndex="2" FieldName="Correo 1" 
                                SummaryType="Count" Area="RowArea" Options-AllowDrag="False" 
                                Options-AllowDragInCustomizationForm="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldCorreo2" AreaIndex="0" FieldName="Correo 2" 
                                SummaryType="Count" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldPresionSistolica" FieldName="Presion Sistolica" 
                                Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldPresionDiastolica" FieldName="Presion Diastolica" 
                                Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldFechaOculista" FieldName="Fecha Oculista" 
                                Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldFechaNutricionista" FieldName="Fecha Nutricionista" 
                                Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldOtrasEnfermedadesnoCurables" 
                                FieldName="Otras Enfermedades no Curables" Visible="False">
                            </dx:PivotGridField>
                            <dx:PivotGridField ID="fieldUrbanizacion" FieldName="Urbanizacion" 
                                Visible="False">
                            </dx:PivotGridField>
                        </Fields>
                        <OptionsCustomization AllowFilterInCustomizationForm="True" />
                        <OptionsChartDataSource FieldValuesProvideMode="DisplayText" 
                            ProvideRowGrandTotals="False" />
                        <OptionsPager ShowDefaultImages="False">
                            <NextPageButton Text="Next &gt;">
                            </NextPageButton>
                            <PrevPageButton Text="&lt; Prev">
                            </PrevPageButton>
                        </OptionsPager>
                        <OptionsLoadingPanel>
                            <Image Url="~/App_Themes/PlasticBlue/PivotGrid/Loading.gif">
                            </Image>
                        </OptionsLoadingPanel>
                        <OptionsLayout Columns-StoreAllOptions="True" Columns-StoreAppearance="True" 
                            StoreAllOptions="True" StoreAppearance="True" StoreClientSideEvents="True" 
                            StoreDataSettings="False" StoreVisualOptions="False" />
                        <Images SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css">
                            <CustomizationFieldsBackground Url="~/App_Themes/PlasticBlue/PivotGrid/pgCustomizationFormBackground.gif">
                            </CustomizationFieldsBackground>
                            <LoadingPanel Url="~/App_Themes/PlasticBlue/PivotGrid/Loading.gif">
                            </LoadingPanel>
                        </Images>
                        <Styles CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" 
                            CssPostfix="PlasticBlue">
                            <MenuStyle GutterWidth="0px" />
                            <CustomizationFieldsCloseButtonStyle>
                                <Paddings Padding="0px" />
                            </CustomizationFieldsCloseButtonStyle>
                        </Styles>
                    </dx:ASPxPivotGrid>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:BDClinicaConnectionString %>" 
                        ProviderName="<%$ ConnectionStrings:BDClinicaConnectionString.ProviderName %>" 
                        SelectCommand="SELECT * FROM [V_Cubo_Admision]"></asp:SqlDataSource>
                    <dx:ASPxPivotGridExporter ID="pvExport" runat="server" Width="183px">
                    </dx:ASPxPivotGridExporter>
                    <br />
                </div>
                <div>

                <div style="overflow: scroll; width: 950px; margin: 0 0 0 0; height: 341px;">
                    <br />
                    <dxchartsui:WebChartControl ID="WebChartControl1" runat="server" 
                        DataSourceID="dgCuboAdmPaciente" Height="290px" RuntimeSelection="True" 
                        SeriesDataMember="Series" Width="850px">
                        <diagramserializable>
                            <cc1:XYDiagram>
                                <axisx visibleinpanesserializable="-1">
                                    <label resolveoverlappingmode="HideOverlapped" staggered="True" />
                                    <range sidemarginsenabled="True" />
                                </axisx>
                                <axisy visibleinpanesserializable="-1">
                                    <range sidemarginsenabled="True" />
                                </axisy>
                            </cc1:XYDiagram>
                        </diagramserializable>
<FillStyle><OptionsSerializable>
<cc1:SolidFillOptions></cc1:SolidFillOptions>
</OptionsSerializable>
</FillStyle>

                        <legend maxhorizontalpercentage="30"></legend>

<SeriesTemplate argumentdatamember="Arguments" valuedatamembersserializable="Values"><ViewSerializable>
    <cc1:SideBySideBarSeriesView>
    </cc1:SideBySideBarSeriesView>
</ViewSerializable>
<LabelSerializable>
    <cc1:SideBySideBarSeriesLabel LineVisible="True" 
        ResolveOverlappingMode="Default">
        <fillstyle>
            <optionsserializable>
                <cc1:SolidFillOptions />
            </optionsserializable>
        </fillstyle>
        <pointoptionsserializable>
            <cc1:PointOptions>
            </cc1:PointOptions>
        </pointoptionsserializable>
    </cc1:SideBySideBarSeriesLabel>
</LabelSerializable>
<LegendPointOptionsSerializable>
<cc1:PointOptions></cc1:PointOptions>
</LegendPointOptionsSerializable>
</SeriesTemplate>
                    </dxchartsui:WebChartControl>
                </div>

                </div>
            </th>
        </tr>
        <tr>
            <td colspan="2">
                &nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">
                &nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">
                <%--<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>"
                    DataSourceMode="DataReader" SelectCommand="usp_Tarifario_ListarTodos" SelectCommandType="StoredProcedure">
                </asp:SqlDataSource>--%>
                <dx:ASPxPopupControl ID="pcMensaje" runat="server"
                CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" CssPostfix="PlasticBlue" 
                Modal="True" PopupHorizontalAlign="WindowCenter" 
                PopupVerticalAlign="WindowCenter" 
                SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" Width="420px" 
                AllowDragging="True" AllowResize="True" ClientInstanceName="pcMensaje" 
                DragElement="Window" HeaderText="Mensaje">
                <HeaderImage Url="~/Imagenes/iconError.png">
                </HeaderImage>
                <LoadingPanelImage Url="~/App_Themes/PlasticBlue/Web/dvLoading.gif">
                </LoadingPanelImage>
                <CloseButtonStyle>
                    <Paddings Padding="0px" />
<Paddings Padding="0px"></Paddings>
                </CloseButtonStyle>
                <ContentStyle>
                    <BorderBottom BorderColor="#E0E0E0" BorderStyle="Solid" BorderWidth="1px" />
<BorderBottom BorderColor="#E0E0E0" BorderStyle="Solid" BorderWidth="1px"></BorderBottom>
                </ContentStyle>
                <HeaderStyle>
                <Paddings PaddingBottom="4px" PaddingLeft="10px" PaddingRight="4px" 
                    PaddingTop="4px" />
<Paddings PaddingLeft="10px" PaddingTop="4px" PaddingRight="4px" PaddingBottom="4px"></Paddings>
                </HeaderStyle>


<ContentCollection>
<dx:PopupControlContentControl ID="PopupControlContentControl2" runat="server" SupportsDisabledAttribute="True">

<table width="100%">
        <tr>
           <td style="padding:0 0 0 20px;">
                <dx:ASPxLabel ID="lblMensaje" runat="server">
                </dx:ASPxLabel>
                <hr />
            </td>
        </tr>
        <tr>        
             <td align="center">
                <dx:ASPxButton ID="ASPxButton3" runat="server" AutoPostBack="False" 
                    ClientIDMode="AutoID" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" 
                    CssPostfix="PlasticBlue" 
                    SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css" Text="Aceptar" 
                    Checked="True">
                    <ClientSideEvents Click="function(s, e) {
	pcMensaje.Hide();   
}" />
                    <CheckedStyle BackColor="#000066" Font-Bold="True" Font-Names="Georgia" 
                        ForeColor="White" Font-Italic="False" Font-Strikeout="False">
                    </CheckedStyle>
                    <HoverStyle BackColor="#000099" Font-Bold="True" Font-Names="Georgia" 
                        ForeColor="White">
                    </HoverStyle>
                </dx:ASPxButton>
            </td>
        </tr>
    </table>

</dx:PopupControlContentControl>
</ContentCollection>
                </dx:ASPxPopupControl>
            </td>
        </tr>
    </table>
</asp:Content>

